home *** CD-ROM | disk | FTP | other *** search
/ Shareware Super Platinum 8 / Shareware Super Platinum 8.iso / mac / DATABASE / MAL38.ZIP;1 / FOXPRO.ZIP / MALPR1.FXP (.txt) < prev    next >
Encoding:
MS Visual FoxPro App  |  1994-04-29  |  7.0 KB  |  143 lines
  1. MALPR1
  2.  Part Mailing Labels
  3. WINDOW
  4. NPR_LBL
  5. NFORM_SCR
  6. BIRTH2
  7. WEDDING2
  8. ACT_DATE2
  9. CADDR_TYPENINDEX
  10. NORDER
  11. 2CPRN
  12. CPR_PRN
  13. OPTION
  14.  .AND. 
  15. mUSER_ID$UPPER(USER_ID)
  16.  .AND. 
  17. mSEX$UPPER(SEX)
  18.  .AND. 
  19. mSTATUS$UPPER(STATUS)
  20.  .AND. 
  21. mHOUSE$UPPER(HOUSE)
  22.  .AND. 
  23. mFIRST$UPPER(FIRST)
  24.  .AND. 
  25. mLAST$UPPER(LAST)
  26.  .AND. 
  27. mADDR_1$UPPER(ADDR_1)
  28.  .AND. 
  29. mADDR_2$UPPER(ADDR_2)
  30.  .AND. 
  31. mCITY$UPPER(CITY)
  32.  .AND. 
  33. mSTATE$UPPER(STATE)
  34.  .AND. 
  35. mZIP$UPPER(ZIP)
  36.  .AND. 
  37. LEN(ALLTRIM(CITY+STATE+ZIP))>0
  38.  .AND. 
  39. mADDR_1$UPPER(SADDR_1)
  40.  .AND. 
  41. mADDR_2$UPPER(SADDR_2)
  42.  .AND. 
  43. mCITY$UPPER(SCITY)
  44.  .AND. 
  45. mSTATE$UPPER(SSTATE)
  46.  .AND. 
  47. mZIP$UPPER(SZIP)
  48.  .AND. 
  49. LEN(ALLTRIM(SCITY+SSTATE+SZIP))>0
  50.  .AND. 
  51. mBIRTH<=BIRTH
  52.  .AND. 
  53. mBIRTH2>=BIRTH
  54.  .AND. 
  55. mWEDDING<=WEDDING
  56.  .AND. 
  57. mWEDDING2>=WEDDING
  58.  .AND. 
  59. mACT_DATE<=ACT_DATE
  60.  .AND. 
  61. mACT_DATE2>=ACT_DATE
  62.  .AND. 
  63. BOL_1
  64.  .AND. 
  65. BOL_2
  66.  .AND. 
  67. BOL_3
  68.  .AND. (
  69. mMESS&cCOUNT = ALLTRIM(  LEFT(mMESS,nCHR-1))
  70. IF LEN(mMESS&cCOUNT) > 0
  71. .OR.8
  72. mMESS
  73. $UPPER(MESS)
  74. .OR.8
  75. mMESS$UPPER(MESS))
  76. SET FILTER TO &cD
  77. Ascending
  78. Descending8
  79. SET ORDER TO nINDEX &cORDER
  80. Press [ESC] to return to main menu...
  81. ?? &cPR_DEF
  82. bESC =.T.
  83. ?? &cPR_DEF
  84. Number of Printed Records = F
  85. USER_ID
  86. MUSER_ID
  87. STATUS
  88. MSTATUS
  89. HOUSE
  90. MHOUSE
  91. YPEFIRST
  92. MFIRST
  93. 2LAST
  94. MLAST
  95. CADDR_TYPEADDR_1
  96. MADDR_1
  97. ADDR_2
  98. MADDR_2
  99. qMCITY
  100. STATE
  101. MSTATE
  102. QMZIP
  103. BIRTH
  104. AMBIRTH
  105. BIRTH2
  106. MBIRTH2
  107. WEDDING
  108. MWEDDING
  109. WEDDING2
  110. AMWEDDING2
  111. ACT_DATE
  112. MACT_DATE
  113. ACT_DATE2
  114. MACT_DATE2BOL_1
  115. BOL_2
  116. BOL_3
  117. qMESS
  118. MMESS
  119. NCOUNT
  120. CCOUNT
  121. CORDER
  122. ANORDER
  123. PLSWAIT
  124. CFILE
  125. ANPAGE
  126. NBUF2
  127. CADDR1
  128. qCADDR2
  129. CADDR3
  130. SADDR_1
  131. PESADDR_2
  132. SCITY
  133. SSTATE
  134. NPR_LBL
  135. NPR_WID
  136. ANPR_COL
  137. NPR_ROW
  138. 1THERM
  139. PRINT
  140. D:\DMAIL4\
  141. MALPR1.FXP
  142. D:\DMAIL4\MALPR1.PRG
  143.